# -*- coding:utf-8 -*-
from sqlalchemy import Column, Integer, String
from utils.mysql import Base

class UserEntity(Base):
    """
    测试表
    """
    __tablename__ = 'user'

    id = Column(Integer, nullable=False, autoincrement=True, primary_key=True, comment='id')
    role_id = Column(Integer, comment='角色名称')
    username = Column(String(50), nullable=False, comment='用户名')
    password = Column(String(100), comment='密码')
    salt = Column(String(64), comment='密码盐')
    real_name = Column(String(50), comment='姓名')
    gender = Column(Integer, comment='性别   0 男   1 女   2未知')
    email = Column(String(100), comment='邮箱')
    mobile = Column(String(20), comment='手机号')
    org_id = Column(Integer, comment='机构ID')
    status = Column(Integer, comment='状态  0：停用   1：正常')
    grade = Column(Integer, comment='年级')
    class_id = Column(String(20), comment='班级')
    speciality_id = Column(String(20), comment='专业')
    code = Column(String(16), comment='学号/工号')
